package com.example.onlinemusic.controller;

import com.example.onlinemusic.mapper.LoveMusicMapper;
import com.example.onlinemusic.mapper.MusicMapper;
import com.example.onlinemusic.model.Music;
import com.example.onlinemusic.model.User;
import com.example.onlinemusic.tools.Constant;
import com.example.onlinemusic.tools.ResponseBodyMessage;
import org.apache.ibatis.binding.BindingException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.File;
import java.io.IOException;
import java.nio.file.Files;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

/**
 * \* Created with IntelliJ IDEA.
 * \* User: Administrator
 * \* Date: 2022/7/26
 * \* Time: 15:41
 * \* To change this template use File | Settings | File Templates.
 * \* Description:
 * \
 */

@RestController
@RequestMapping("/music")
public class MusicController {
    //从配置文件读取路径
    @Value("${music.local.path}")//音乐上传后的路径
    private String SAVE_PATH/* = "C:/work/local/music1/"*/;

    @Autowired
    private MusicMapper musicMapper;

    @Resource
    private LoveMusicMapper LoveMusicMapper;

    @RequestMapping("/upload")
    public ResponseBodyMessage<Boolean> insertMusic(@RequestParam String singer,
                                                    @RequestParam("filename") MultipartFile file,
                                                    HttpServletRequest request,
                                                    HttpServletResponse resp) throws IOException {
        //1.检查是否登录
        HttpSession httpSession = request.getSession(false);
        if (httpSession == null || httpSession.getAttribute(Constant.USERINFO_SESSION_KEY) == null) {
            System.out.println("没有登录！");
            return new ResponseBodyMessage<>(-1, "请登陆后上传", false);
        }

        //2.上传到服务器
        String fileNameAndType = file.getOriginalFilename();//获取文件

        System.out.println("fileNameAndType:" + fileNameAndType);

        String path = SAVE_PATH + "/" + fileNameAndType;

        File dest = new File(path);

        if (dest.exists()) {
            dest.mkdir();
        }
        try {
            file.transferTo(dest);
            //  return new ResponseBodyMessage<>(0,"上传成功!",true);
        } catch (IOException e) {

            e.printStackTrace();
            return new ResponseBodyMessage<>(-1, "服务器上传失败!", false);
        }
        //return new ResponseBodyMessage<>(-1,"失败!",false);

        // 这里我们需要先查询歌曲是否存在， 判断歌曲名和歌手


        //3.进行数据库的上传
        //(1)准备需要的数据
        int index = fileNameAndType.lastIndexOf(".");
        String title = fileNameAndType.substring(0, index);

        User user = (User) httpSession.getAttribute(Constant.USERINFO_SESSION_KEY);
        int userid = user.getId();
        //作用：播放音乐 -> 发送http请求
        String url = "/music/get?path=" + title;

        SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
        String time = sf.format(new Date());
        //(2)调用insert

        try {
            int ret = 0;
            ret = musicMapper.insert(title, singer, time, url, userid);
            if (ret == 1) {
                //上传成功，跳转到音乐列表
                resp.sendRedirect("/list.html");
                return new ResponseBodyMessage<>(0, "数据库上传成功!", true);
            } else {
                return new ResponseBodyMessage<>(-1, "数据库上传失败!", false);
            }
        } catch (BindingException e) {
            dest.delete();
            return new ResponseBodyMessage<>(-1, "数据库上传失败!", false);
        }
    }
        //重复上传歌曲能否成功？

    /**
     * 播放音乐的时候，/music/get?path=xxx.mp3
     * @param path
     * @return
     */
    @RequestMapping("/get")
    public ResponseEntity<byte[]> func(String path) {
        File file = new File(SAVE_PATH+"/" + path);
        byte[] a = null;
        try {
            a = Files.readAllBytes(file.toPath());//读取文件中的所有字节，读入内存 ，参数path是文件的路径
            if(a == null){
                return ResponseEntity.badRequest().build();
            }
            return ResponseEntity.ok(a);
        } catch (IOException e) {
            e.printStackTrace();
        }
        //return ResponseEntity.internalServerError().build();
      //  return ResponseEntity.notFound().build();
        return ResponseEntity.badRequest().build();
    }

    /**
     * 删除单个音乐
     * @param id
     * @return
     */
    @RequestMapping("/delete")
    public ResponseBodyMessage<Boolean> deleteMusicById(@RequestParam String id){
        //1.先检查音乐是否存在
        int iid = Integer.parseInt(id);
        //2.如果存在，则删除
        Music music = musicMapper.finMusicById(iid);
        if(music == null){
            System.out.println("没有这个id的音乐");
            return new ResponseBodyMessage<>(-1,"没有你要删除的音乐",false);
        }else {
            //2.1.删除数据库
            int ret = musicMapper.deleteMusicById(iid);
            if(ret == 1){
                //2.2.删除服务器上的数据
                int index = music.getUrl().lastIndexOf("=");
                String fileName = music.getUrl().substring(index+1);

                //加上后缀mp3
                File file = new File(SAVE_PATH+"/"+fileName+".mp3");
                System.out.println("当前的路径："+file.getPath() );
                if(file.delete()){
                    //同步删除lovemusic表单中这个音乐
                    LoveMusicMapper.deleteLoveMusicByMusicId(iid);
                    return new ResponseBodyMessage<>(0,"服务器中的音乐删除成功！",true);
                }else {
                    return new ResponseBodyMessage<>(-1,"服务器中的音乐删除失败",false);
                }
            }else {
                return new ResponseBodyMessage<>(-1,"数据库当中的音乐没有删除成功",false);
            }

        }

    }

    /**
     * 批量删除
     * @param id
     * @return
     */
    @RequestMapping("/deleteSel")
    public ResponseBodyMessage<Boolean> deleteSelMusic(@RequestParam("id[]")List<Integer> id){
        System.out.println("所有的ID："+id);
        int sum = 0;
        for(int i = 0; i < id.size() ;i++){
            int musicId = id.get(i);
            Music music = musicMapper.finMusicById(musicId);
            if(music == null){
                System.out.println("没有这个id的音乐");
                return new ResponseBodyMessage<>(-1,"没有你要删除的音乐",false);
            }
            int ret = musicMapper.deleteMusicById(id.get(i));
            if(ret == 1){
                //2.2.删除服务器上的数据
                int index = music.getUrl().lastIndexOf("=");
                String fileName = music.getUrl().substring(index+1);

                File file = new File(SAVE_PATH+"/"+fileName+".mp3");
                if(file.delete()){
                    //同步删除lovemusic表单中这个音乐
                    LoveMusicMapper.deleteLoveMusicByMusicId(musicId);
                    sum += ret;
                    //return new ResponseBodyMessage<>(0,"服务器中的音乐删除成功！",true);
                }else {
                    System.out.println("删除失败！");
                    return new ResponseBodyMessage<>(-1,"服务器中的音乐删除失败",false);
                }
            }else {
                return new ResponseBodyMessage<>(-1,"数据库中的音乐删除失败",false);
            }
        }
        if(sum == id.size()){
            System.out.println("整体删除成功");
            return new ResponseBodyMessage<>(0,"音乐删除成功！",true);
        }else {
            System.out.println("整体删除失败");
            return new ResponseBodyMessage<>(-1,"音乐删除失败！",false);
        }
    }

    @RequestMapping("/findmusic")
    public ResponseBodyMessage<List<Music>> findMusic(@RequestParam(required = false) String musicName){
        List<Music> musicList = null;
        if(musicName != null){
            musicList = musicMapper.findMusicByName(musicName);
        }else {
            musicList = musicMapper.findMusic();
        }
        return new ResponseBodyMessage<>(0,"查询到了所有的音乐",musicList);
    }
}
